> -
- Rate Projections Functions Walkthrough
- Accruals and Cash
- Repeating Formulae
- Range Names and References
- Optional Parameters
- Using PmtsPerYear
- Modelling Seasonality
- Calculating Interest
- Using Business Functions in VBA (Visual Basic for Applications)
- Array Functions
- Volatility
- Annual Equivalent Rates
- Array Function
- Auto Multi Functions
- Variable Plurality
- GoalSeek
Named Range Manager | |
| Re-define and delete range names | |
| This utility presents you with al the range names in a workbook, in a way where you can examine them by sheet, by the whole workbook, or just looking at those names which are "hidden" (don"t refer to any one cell). When you select a range name you can "go to" its location, delete it, or change its definition. The utility is particularly useful for changing the definitions of non-trivial range names, for example those that have relative references (the definition box will automatically present these in R1C1 format), or long definitions, where the definition box is simply bigger than Excels own facility (Insert/Name/Define). Also, whe utility does not have any live cursor pointing behaviour (known as RefEdit to those in the know), which means that that the reference is just what you type, which is a more direct way of setting name definitions. We advise you read up on range names at a website like our own or John Walkenbachs if you going to make extensive use of range names. Range names are great, but there are some behaviours that are a bit odd: the main thing to bear in mind is that they are not really "named ranges" as such - they are named formulae, which is a slightly but significantly different thing. |